/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sv.com.intesal.seguridad.sql;

/**
 *
 * @author ejerez
 */
public class SQLMenuModelo {

    public static final String getMenu_x_Usuario_inicial = "select * from menu as m,tipo_menu as tm where tm.codigo_tm=m.codigo_tm and m.codigo_papa_m=0 and m.estado_m='A' and tm.estado_tm='A' order by m.codigo_tm,m.nivel_m,ordenar_m";
    public static final String getMenu_x_Usuario_final = "select * from menu as m,tipo_menu as tm where tm.codigo_tm=m.codigo_tm and m.codigo_papa_m=? and m.estado_m='A' and tm.estado_tm='A' order by m.codigo_tm,m.nivel_m,ordenar_m";
    public static final String getMenu_x_Codigo = "select * from menu as m,tipo_menu as tm where tm.codigo_tm=m.codigo_tm and m.codigo_m=? and m.estado_m='A' and tm.estado_tm='A' order by m.codigo_tm,m.nivel_m,ordenar_m";
    public static final String getMenu_x_Usuario_validar = "select count(codigo_m) as contar from menu as m,tipo_menu as tm where tm.codigo_tm=m.codigo_tm and m.codigo_papa_m=? and m.estado_m='A' and tm.estado_tm='A'";
}
